SPR

Technote

Problem:
There are several reasons why this issue may occur:

1. There is no default view present in the database.
2. The view being used is a Private view stored in the Desktop.
3. The formula or action is trying to either include a link to the document OR
include a copy of the document.

Each reason is detailed below.

1. There is no default view present in the database.

Designate one of the views in the database as the default by enabling the view
property, 'Default when database is first opened'. Once this change is made,
the @MailSend will work both with and without the [IncludeDocLink] parameter.

Lotus Quality Engineering is aware of the change in functionality
(#CMUY397UER). It will not be addressed in R4 and there are no plans to
address it in Notes R5.

This issue has been addressed in the mail templates which ship with Notes 6.0
(spr #ENL4QWKV3). The Inbox folder is now set as the default view.

Note: This issue also applies to the Simple Action "Send Mail Message" with
the "Include Document Link" option checked; however, the Agent Log (viewed by
highlighting the agent and selecting Agent, Log) will have the error message
"ERROR: Special database object cannot be located". Specifying a default view
for the database resolves the issue. This issue has been reported to Lotus
Quality Engineering (spr #ASHW4U7U4P). This error message is not accurate since
the problem with the database is that there is no default view.


2. The view being used is a Private view stored in the Desktop.

This issue was addressed in Notes 4.6.2. It was reportedly fixed in 4.5.5;
however, it was not completely fixed. It appears to be fixed in 4.5.6.

Excerpt from Notes/Domino 4.6.2 QMR Fix List:

Client/Workstation
SPR# CGOZ3QZNR9 - Allow the use of @MailSend in private database views.

Please note that this issue also occurs in Notes R5; it was reported to Lotus
Quality Engineering, and was addressed in Notes 5.0.9 Client.

Excerpt from the Lotus Notes and Domino Release 5.0.9 MR fix list (available at
http://www.notes.net):

Editor - Links & URLs
SPR# RMAS4LHHRH - Fixed a problem where @mailsend when included with a doclink
would fail if sent from within an active private view.

Basic workarounds for this issue as related to private views:

If the view is a Personal view (as opposed to a "Shared - Private on first use"
view), enable the 'Create Personal Folders/Views' property in each user's ACL
access. The users would then need to re-create the view.

If the view is a "Shared - Personal on first use" view, the designer should
re-create the view, making sure not to enable the View option, 'Store in
Desktop'.

If the designers of the application would rather not use the above workarounds
there is one more alternative. This involves creating an additional view, and
an agent. The current trigger (button or agent) for the @MailSend would be
adapted to call the agent. The agent in turn calls a Shared view and executes
the @MailSend:

- The Shared view created is called "UNID". The view will consist of one
sorted column, using the column formula:

@Text(@DocumentUniqueID)

- The new agent is called "SendMail", and it has the following settings:

When should this agent run?: Manually from Actions menu.
Which document(s) should it act on?: Selected documents
Formula (this would actually be set up as the current application's @MailSend):

@MailSend(SendTo;"";"";"";"";"";[IncludeDoclink]);Select @All

- The current button or agent for the @MailSend instead performs the following:

ID := @Text(@DocumentUniqueID);
@Command([OpenView]; "UNID"; ID);
@Command([ToolsRunMacro]; "SendMail")



3. The formula or action is trying to either:

- include a link to the document
-OR-
- include a copy of the document

The document you are trying to send must be saved before sending. For example,
it is not advisable to trigger the send within a form's QuerySave event, as the
document is not saved yet. Again, the error message for not saving first is
"Special database object cannot be located."

For example, if either of the following checkboxes are selected on a simple
action that does "Send Mail Message":

Include link to document
Include copy of document

...then the document must be saved before clicking the simple action can send
it. The reason for the error is that the document is not yet stored in the
view index, so Notes can't find it and therefore can't make a link to it, nor a
copy of it. If the application developer wants to prevent user confusion,
he/she could add code that would save the document automatically before Notes
sends it.

Alternately, the application developer can opt not to include a link or a
copy. Only the subject and body, specified in the simple action dialog box,
will be sent to the recipient so the document doesn't need to be saved first.

Supporting Information:

The agent will send mail if run manually (not scheduled), or if the
[IncludeDocLink] parameter is removed.

To enable the 'Default When Database Is First Opened' view property, determine
which view will be the default and open it in Design mode. Then select Design,
View Properties, and select the Options tab on the InfoBox. Select the
'Default When Database Is First Opened' box and then save the view.


Private views can be stored on the local desktop in two different methods:

1. Private views created by a user will be stored in the desktop if the user's
ACL access entry does not have the following ACL property enabled: 'Create
Personal Folders/Views'

2. The view may also be set up as a "Shared - Private on first use" view. In
this case the designer can specify that the view be stored on the desktop.

Related Documents:

"Choose Server to Search" Dialog Box Displays After Clicking Certain Doclinks
Document #: 1101447 (152960)

AS/400: Scheduled Agents that Include @MAILSEND or Send Method Do Not Deliver
Mail
Document #: 1096556 (170217)

"Special Database Object Cannot be Located" Using @MailSend with
[IncludeDocLink] in Mail Database
Document #: 1087368 (194196) More >